USE Travian

INSERT INTO races VALUES('Romans');
INSERT INTO races VALUES('Teutons');
INSERT INTO races VALUES('Gauls');

INSERT INTO units Values('Legionnaire', 'Romans', 6, 50, 'M', 'I');
INSERT INTO units Values('Praetoriaan', 'Romans', 5, 20, 'D', 'I');
INSERT INTO units Values('Imperiaan', 'Romans', 7, 50, 'A', 'I');
INSERT INTO units Values('Equites legati', 'Romans', 16, 0, 'S', 'H');
INSERT INTO units Values('Equites imperatoris', 'Romans', 14, 100, 'A', 'H');
INSERT INTO units Values('Equites Caesaris', 'Romans', 10, 70, 'A', 'H');
INSERT INTO units Values('Battering Ram', 'Romans', 4, 0, 'A', 'S');
INSERT INTO units Values('Fire Catapult', 'Romans', 3, 0, 'A', 'S');
INSERT INTO units Values('Senator', 'Romans', 4, 0, 'C', 'C');
INSERT INTO units Values('Settler', 'Romans', 5, 3000, 'C', 'C');
INSERT INTO units Values('Clubswinger', 'Teutons', 7, 60, 'A', 'I');
INSERT INTO units Values('Spearmen', 'Teutons', 7, 40, 'D', 'I');
INSERT INTO units Values('Axeman', 'Teutons', 6, 50, 'A', 'I');
INSERT INTO units Values('Scout', 'Teutons', 9, 0, 'S', 'H');
INSERT INTO units Values('Paladin', 'Teutons', 10, 110, 'D', 'H');
INSERT INTO units Values('Teutonic Knight', 'Teutons', 9, 80, 'A', 'H');
INSERT INTO units Values('Ram', 'Teutons', 4, 0, 'A', 'S');
INSERT INTO units Values('Catapult', 'Teutons', 3, 0, 'A', 'S');
INSERT INTO units VALUES('Chief', 'Teutons', 4, 0, 'C', 'C');
INSERT INTO units VALUES('Settler', 'Teutons', 5, 3000, 'C', 'C');
INSERT INTO units VALUES('Phalanx', 'Gauls', 7, 35, 'D', 'I');
INSERT INTO units VALUES('Swordsman', 'Gauls', 6, 45, 'A', 'I');
INSERT INTO units VALUES('Pathfinder', 'Gauls', 17, 0, 'S', 'H');
INSERT INTO units VALUES('Theutates Thunder', 'Gauls', 19, 75, 'A', 'H');
INSERT INTO units VALUES('Druidrider', 'Gauls', 16, 35, 'D', 'H');
INSERT INTO units VALUES('Haeduan', 'Gauls', 13, 65, 'M', 'H');
INSERT INTO units VALUES('Ram', 'Gauls', 4, 0, 'A', 'S');
INSERT INTO units VALUES('Trebuchet', 'Gauls', 3, 0, 'A', 'S');
INSERT INTO units VALUES('Chieftain', 'Gauls', 5, 0, 'C', 'C');
INSERT INTO units VALUES('Settler', 'Gauls', 5, 3000, 'C', 'C');

INSERT INTO commands VALUES('Travian', 3);
INSERT INTO commands VALUES('Troepen', 3);
INSERT INTO commands VALUES('Forum', 3);
INSERT INTO commands VALUES('Chat', 3);
INSERT INTO commands VALUES('Findally', 3);
INSERT INTO commands VALUES('Findplayer', 3);
INSERT INTO commands VALUES('Getmember', 10);
INSERT INTO commands VALUES('Addmember', 10);
INSERT INTO commands VALUES('Refresh', 10);
INSERT INTO commands Values('Kick', 10);
INSERT INTO commands Values('Invite', 5);
INSERT INTO commands Values('Getdistance', 3);
INSERT INTO commands Values('Gettroops', 10);
INSERT INTO commands Values('Farm', 3);
